TrafMeter :: Database Table for Packet Logging

Database Table for Packet Logging

You must manually create the table in the database before TrafMeter will record IP packets. A minimal set of the fields in the table is:

N Field name Field type Description
1. filterid smallint Filter id (from 1 to N. In general, N is a number of filters in the filterset)
2. proto smallint IP protocol type
(1 - ICMP, 6 - TCP, 17 - UDP and etc. See "protocols.txt" for details)
3. src_ip char(16) Source address IP (in decimal-dotted notation, e.g. 192.168.3.250)
4. src_port int Source port (for TCP or UDP only, the range is 0 - 65535)
5. dst_ip char(16) Destination address IP
6. dst_port int Destination port (for TCP or UDP only)
7. sent int Sent bytes counter
8. recv int Received bytes counter

In additional, if you enable a logging of MAC addresses, TOS (Type of Service) field or Filter Name in the packets database, you should create additional fields in the table:

N	Field name	Field type	Description
9.	src_mac	char(16)	Source MAC address (e.g. 1a2c3e4d556f)
10.	dst_mac	char(16)	Destination MAC address
11.	tos	smallint	TOS (Type of Service) field (the range is 0-255)
12.	filtername	char(30)	The filter name (The length of this field must be the length of the longest Filter Name in the filterset)